-
Create the table with one geometry column, one ID, one angle field, and one foreign key.
CREATE TABLE DEVICE_TIME
(Id NUMBER PRIMARY KEY,
MYFROMDATE DATE,
MYTODATE DATE,
GEOMETRY MDSYS.SDO_GEOMETRY);
-
Insert the table metadata in the Oracle Spatial metadata.
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES (‘DEVICE_TIME', 'GEOMETRY',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050),
MDSYS.SDO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050) ),
82247);
COMMIT;
-
Create the spatial index of type point to use rotation.
CREATE INDEX devicetime_idx ON DEVICE_TIME(Geometry) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('layer_gtype=point');
-
Insert some example data.
insert into device_time values(1, TO_DATE('01-01-1991', 'MM-DD-YYYY'), TO_DATE('01-01-1999', 'MM-DD-YYYY'), null);
insert into device_time values(2, TO_DATE('02-02-1991', 'MM-DD-YYYY'), NULL, null);
commit;
-
Enable versionning.
EXECUTE DBMS_WM.EnableVersioning('DEVICE_TIME','NONE',FALSE,TRUE);
-
Update the WM_VALID From and To Time using the date existing fields.
update device_time a set a.wm_valid.validfrom = myfromdate, a.wm_valid.validtill = mytodate;
commit;
